select * from CLIENTES_ATACADO order by prioridade

select * from CLIENTES_ATACADO WHERE PRIORIDADE in ('2','3','4','5')order by prioridade

/*
begin transaction
update CLIENTES_ATACADO set prioridade = '1'
WHERE PRIORIDADE in ('2','3','4','5')
commit
rollback                                   
*/

/*
begin transaction
UPDATE LOJA_NOTA_FISCAL SET SERIE_NF = '2'
WHERE CODIGO_FILIAL = '000148' AND NF_NUMERO like '000208'AND CODIGO_ITEM = 'V7MTZ3975048'   
commit
rollback                                   
*/

